UR- Uncommitted Read:
It is good for accessing read-only tables and read-only queries.
No record Locking is done.
CS- Cursor Stability:
<> It is a default isolation level.
<> It locks or unlocks each row at a time.
<> It guarantees to return only data which was committed at the time of reading.
RS- Read Stability:
<> It releases Locks on rows that do not satisfy the query predicates.
<> It is used for result set stability or when the future actions on returned rows may be taken.
RR- Repeatable Read:
<> It allows the application to retrieve and operate on rows as many times as needed.
<> It locks the entire table.
Posted Date:- 2021-09-03 08:43:48
Mention the way of highlighting as well as putting a CURSOR to use in a COBOL program.
Comment whether the cursor is closed during COMMIT or not.
Distinguish between segmented, simple, and partitioned tablespaces:
Explain correlated sub-queries.
What is the information associated with SYSIBM.SYSLINKS table?
How can tablespace be moved to another DASD volume that is allocated for that tablespace?
Explain the Function done by data manager?
What do you mean by a recovery log?
Distinguish between segmented, simple, and partitioned tablespaces:
Describe the four environments that access DB2:
Define the value function purpose:
What does the buffer manager do?
What is meant by SQL Communication Area?
What does Data Warehousing use?
What Does Dsndb07 Database Do?
What Is Declaration Generator(dclgen)?
What Is A Database Request Module(dbrm)?
What Is The Function Of The Data Manager?
What Will The Commit Accomplish?
On The Create Tablespace, What Does The Close Parameter Do?
How Many Buffer Pools Are There In Db2?
Explain various types of Locks in DB2?
What are the full forms of SPUFI and DCLGEN and why are they used?
Give a brief description of DB2 Isolation Levels?
What is meant by the attachment facility?
What information is used as input to the binding process?
Describe major components of DB2?
Explain PACKAGE in DB2 and its advantages?
What is Buffer pool and list some of them?